Creating Slicers
18
Creating Slicers for the dashboard
Step 1:Creating Year slicer.
Click on slicer, select the year in the date table then click on the arrow in the slicer and select List. In the filters pane under filters on this visuals, click on expand button and select Basic filtering from the dropdown list, select all and uncheck (Blank).
a. To Format, in General Orientation horizontal, responsive on, X position = 896, y position = 116,
width = 384, height = 78.
b. Selection Control, multi-select with CTRL ON and select all option OFF, Slicer header OFF
c. Items, font color =black, background color=a0d1ff, text size=10, font family =Segoe UI
d. Title = Year, font color= black, background color = white, alignment = left, text size =12,Font family = Ariel Black
e. Background ON, color = white, transparency = 0%, Visual header ON
Follow the same to create a month slicer, copy the year slicer (ctrl+c) and Paste it (ctrl+v) then remove the Year in the fields pane and select month in the date table.
To Format, in General Orientation horizontal, responsive on, X position = 125, y position = 195,
width = 1155, height = 78.
change the title as Month.
follow the gif for visualization purpose.
Step 2. Creating Survey Type, Question Text, QType, Interviewer, and Interviewee slicers.
To create survey type slicer click on the slicer, select survey type column from IMockInterviewcritique table in the field value, then click on the arrow in the slicer and select dropdown.
Slicer 1. Survey Type
a. To Format, in General X position = 0, y position = 270,
width = 232, height = 90.
b. Slicer header ON, font color =black, background color=white, text size =12,font family=Segoe (bold)
c. Items, font color =black, background color=white, text size=13, font family =Segoe UI
d. Title OFF
e. Background ON, color = white, transparency = 0%, Visual header ON
copy and paste it to create 4 remaining slicers.
Slicer 2. Question Text, change the field value.
Drag and drop the Question Text column from IMockInterviewcritique table to the field value.a. To Format, in General X position = 0, y position = 360,
width = 232, height = 90.
Slicer 3. QType, change the field value. Drag and drop the QType column in the field value.
a. To Format, in General X position = 0, y position = 450,
width = 232, height = 90.
Slicer 4. Interviewer, change the field value. Drag and drop the Interviewer column from Interviewer table to the field value.
Click on the slicer, In the filters pane under filters on this visuals, click on expand button and select Basic filtering from the dropdown list, select all and uncheck (Blank).
a. To Format, in General X position = 0, y position = 540,
width = 232, height = 90.
Slicer 5. Interviewee, change the field value. Drag and drop the Interviewee column in the Interviewee table to the field value.
Click on the slicer, In the filters pane under filters on this visuals, click on expand button and select Basic filtering from the dropdown list, select all and uncheck (Blank).
a. To Format, in General X position = 0, y position = 630,
width = 232, height = 90.
follow the gif below:
Use the link below creating slicers in power bi:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers
Creating Slicers
18
Creating Slicers for the dashboard
Step 1:Creating Year slicer.
Click on slicer, select the year in the date table then click on the arrow in the slicer and select List. In the filters pane under filters on this visuals, click on expand button and select Basic filtering from the dropdown list, select all and uncheck (Blank).
a. To Format, in General Orientation horizontal, responsive on, X position = 896, y position = 116,
width = 384, height = 78.
b. Selection Control, multi-select with CTRL ON and select all option OFF, Slicer header OFF
c. Items, font color =black, background color=a0d1ff, text size=10, font family =Segoe UI
d. Title = Year, font color= black, background color = white, alignment = left, text size =12,Font family = Ariel Black
e. Background ON, color = white, transparency = 0%, Visual header ON
Follow the same to create a month slicer, copy the year slicer (ctrl+c) and Paste it (ctrl+v) then remove the Year in the fields pane and select month in the date table.
To Format, in General Orientation horizontal, responsive on, X position = 125, y position = 195,
width = 1155, height = 78.
change the title as Month.
follow the gif for visualization purpose.
Step 2. Creating Survey Type, Question Text, QType, Interviewer, and Interviewee slicers.
To create survey type slicer click on the slicer, select survey type column from IMockInterviewcritique table in the field value, then click on the arrow in the slicer and select dropdown.
Slicer 1. Survey Type
a. To Format, in General X position = 0, y position = 270,
width = 232, height = 90.
b. Slicer header ON, font color =black, background color=white, text size =12,font family=Segoe (bold)
c. Items, font color =black, background color=white, text size=13, font family =Segoe UI
d. Title OFF
e. Background ON, color = white, transparency = 0%, Visual header ON
copy and paste it to create 4 remaining slicers.
Slicer 2. Question Text, change the field value.
Drag and drop the Question Text column from IMockInterviewcritique table to the field value.a. To Format, in General X position = 0, y position = 360,
width = 232, height = 90.
Slicer 3. QType, change the field value. Drag and drop the QType column in the field value.
a. To Format, in General X position = 0, y position = 450,
width = 232, height = 90.
Slicer 4. Interviewer, change the field value. Drag and drop the Interviewer column from Interviewer table to the field value.
Click on the slicer, In the filters pane under filters on this visuals, click on expand button and select Basic filtering from the dropdown list, select all and uncheck (Blank).
a. To Format, in General X position = 0, y position = 540,
width = 232, height = 90.
Slicer 5. Interviewee, change the field value. Drag and drop the Interviewee column in the Interviewee table to the field value.
Click on the slicer, In the filters pane under filters on this visuals, click on expand button and select Basic filtering from the dropdown list, select all and uncheck (Blank).
a. To Format, in General X position = 0, y position = 630,
width = 232, height = 90.
follow the gif below:
Use the link below creating slicers in power bi:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-slicers